import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
import plotly.express as px
import plotly.io as pio
netflix = pd.read_csv("netflix_titles.csv")
netflix.head()
| show_id | type | title | director | cast | country | date_added | release_year | rating | duration | listed_in | description | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | s1 | TV Show | 3% | NaN | João Miguel, Bianca Comparato, Michel Gomes, R... | Brazil | August 14, 2020 | 2020 | TV-MA | 4 Seasons | International TV Shows, TV Dramas, TV Sci-Fi &... | In a future where the elite inhabit an island ... |
| 1 | s2 | Movie | 7:19 | Jorge Michel Grau | Demián Bichir, Héctor Bonilla, Oscar Serrano, ... | Mexico | December 23, 2016 | 2016 | TV-MA | 93 min | Dramas, International Movies | After a devastating earthquake hits Mexico Cit... |
| 2 | s3 | Movie | 23:59 | Gilbert Chan | Tedd Chan, Stella Chung, Henley Hii, Lawrence ... | Singapore | December 20, 2018 | 2011 | R | 78 min | Horror Movies, International Movies | When an army recruit is found dead, his fellow... |
| 3 | s4 | Movie | 9 | Shane Acker | Elijah Wood, John C. Reilly, Jennifer Connelly... | United States | November 16, 2017 | 2009 | PG-13 | 80 min | Action & Adventure, Independent Movies, Sci-Fi... | In a postapocalyptic world, rag-doll robots hi... |
| 4 | s5 | Movie | 21 | Robert Luketic | Jim Sturgess, Kevin Spacey, Kate Bosworth, Aar... | United States | January 1, 2020 | 2008 | PG-13 | 123 min | Dramas | A brilliant group of students become card-coun... |
fig=px.bar(netflix, x="type", title="Shows vs Movies")
fig.show()
pio.write_html(fig,"test.html", full_html=False)
tsv_file = pd.read_csv("title.basics.tsv.gz",sep="\t")
tsv_file.head()
ratings=px.bar(netflix, x="type", y='ratings', title="Shows vs Movies") ratings.show()
tvshows = netflix[netflix['type']=='TV Show']
tvshows.head()
movies = netflix[netflix['type']=='Movie']
movies.head()
| show_id | type | title | director | cast | country | date_added | release_year | rating | duration | listed_in | description | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | s2 | Movie | 7:19 | Jorge Michel Grau | Demián Bichir, Héctor Bonilla, Oscar Serrano, ... | Mexico | December 23, 2016 | 2016 | TV-MA | 93 min | Dramas, International Movies | After a devastating earthquake hits Mexico Cit... |
| 2 | s3 | Movie | 23:59 | Gilbert Chan | Tedd Chan, Stella Chung, Henley Hii, Lawrence ... | Singapore | December 20, 2018 | 2011 | R | 78 min | Horror Movies, International Movies | When an army recruit is found dead, his fellow... |
| 3 | s4 | Movie | 9 | Shane Acker | Elijah Wood, John C. Reilly, Jennifer Connelly... | United States | November 16, 2017 | 2009 | PG-13 | 80 min | Action & Adventure, Independent Movies, Sci-Fi... | In a postapocalyptic world, rag-doll robots hi... |
| 4 | s5 | Movie | 21 | Robert Luketic | Jim Sturgess, Kevin Spacey, Kate Bosworth, Aar... | United States | January 1, 2020 | 2008 | PG-13 | 123 min | Dramas | A brilliant group of students become card-coun... |
| 6 | s7 | Movie | 122 | Yasir Al Yasiri | Amina Khalil, Ahmed Dawood, Tarek Lotfy, Ahmed... | Egypt | June 1, 2020 | 2019 | TV-MA | 95 min | Horror Movies, International Movies | After an awful accident, a couple admitted to ... |
fig=px.bar(tvshows, x="rating", title="Shows")
fig.show()
pio.write_html(fig,"tvshows.html", full_html=False)
fig=fig = px.pie(netflix, names='country', title='Countries')
fig.show()
fig=fig = px.pie(netflix, names='release_year', title='years')
fig.show()
pio.write_html(fig,"movies.html", full_html=False)
fig=px.bar(netflix, x="rating", title="Movies")
fig.show()
fig=fig = px.pie(netflix, names='release_year', title='Years')
fig.show()
fig=fig = px.pie(movies, names='release_year', title='Movie release years')
fig.show()
twentytwenty = movies[movies['release_year']==2020]
twentytwenty.head()
| show_id | type | title | director | cast | country | date_added | release_year | rating | duration | listed_in | description | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27 | s28 | Movie | #Alive | Cho Il | Yoo Ah-in, Park Shin-hye | South Korea | September 8, 2020 | 2020 | TV-MA | 99 min | Horror Movies, International Movies, Thrillers | As a grisly virus rampages a city, a lone man ... |
| 30 | s31 | Movie | #cats_the_mewvie | Michael Margolis | NaN | Canada | February 5, 2020 | 2020 | TV-14 | 90 min | Documentaries, International Movies | This pawesome documentary explores how our fel... |
| 32 | s33 | Movie | #FriendButMarried 2 | Rako Prijanto | Adipati Dolken, Mawar de Jongh, Sari Nila, Von... | Indonesia | June 28, 2020 | 2020 | TV-G | 104 min | Dramas, International Movies, Romantic Movies | As Ayu and Ditto finally transition from best ... |
| 43 | s44 | Movie | Òlòtūré | Kenneth Gyang | Beverly Osu, Sharon Ooja, Omowunmi Dada, Pearl... | Nigeria | October 2, 2020 | 2020 | TV-MA | 107 min | Dramas, International Movies | In Lagos, a journalist goes undercover as a pr... |
| 57 | s58 | Movie | 100% Halal | Jastis Arimba | Anisa Rahma, Ariyo Wahab, Anandito Dwis, Fitri... | Indonesia | January 7, 2021 | 2020 | TV-14 | 101 min | Dramas, International Movies | After high school, a young woman marries the m... |
twentynineteen = movies[movies['release_year']==2019]
twentynineteen.head()
| show_id | type | title | director | cast | country | date_added | release_year | rating | duration | listed_in | description | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6 | s7 | Movie | 122 | Yasir Al Yasiri | Amina Khalil, Ahmed Dawood, Tarek Lotfy, Ahmed... | Egypt | June 1, 2020 | 2019 | TV-MA | 95 min | Horror Movies, International Movies | After an awful accident, a couple admitted to ... |
| 8 | s9 | Movie | 706 | Shravan Kumar | Divya Dutta, Atul Kulkarni, Mohan Agashe, Anup... | India | April 1, 2019 | 2019 | TV-14 | 118 min | Horror Movies, International Movies | When a doctor goes missing, his psychiatrist w... |
| 14 | s15 | Movie | 3022 | John Suits | Omar Epps, Kate Walsh, Miranda Cosgrove, Angus... | United States | March 19, 2020 | 2019 | R | 91 min | Independent Movies, Sci-Fi & Fantasy, Thrillers | Stranded when the Earth is suddenly destroyed ... |
| 18 | s19 | Movie | 15-Aug | Swapnaneel Jayakar | Rahul Pethe, Mrunmayee Deshpande, Adinath Koth... | India | March 29, 2019 | 2019 | TV-14 | 124 min | Comedies, Dramas, Independent Movies | On India's Independence Day, a zany mishap in ... |
| 28 | s29 | Movie | #AnneFrank - Parallel Stories | Sabina Fedeli, Anna Migotto | Helen Mirren, Gengher Gatti | Italy | July 1, 2020 | 2019 | TV-14 | 95 min | Documentaries, International Movies | Through her diary, Anne Frank's story is retol... |
twentyeighteen = movies[movies['release_year']==2018]
twentyeighteen.head()
| show_id | type | title | director | cast | country | date_added | release_year | rating | duration | listed_in | description | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13 | s14 | Movie | 2,215 | Nottapon Boonprakob | Artiwara Kongmalai | Thailand | March 1, 2019 | 2018 | TV-MA | 89 min | Documentaries, International Movies, Sports Mo... | This intimate documentary follows rock star Ar... |
| 17 | s18 | Movie | 22-Jul | Paul Greengrass | Anders Danielsen Lie, Jon Øigarden, Jonas Stra... | Norway, Iceland, United States | October 10, 2018 | 2018 | R | 144 min | Dramas, Thrillers | After devastating terror attacks in Norway, a ... |
| 20 | s21 | Movie | Kuch Bheege Alfaaz | Onir | Geetanjali Thapa, Zain Khan Durrani, Shray Rai... | India | September 1, 2018 | 2018 | TV-14 | 110 min | Dramas, Independent Movies, International Movies | After accidentally connecting over the Interne... |
| 21 | s22 | Movie | Goli Soda 2 | Vijay Milton | Samuthirakani, Bharath Seeni, Vinoth, Esakki B... | India | September 15, 2018 | 2018 | TV-14 | 128 min | Action & Adventure, Dramas, International Movies | A taxi driver, a gangster and an athlete strug... |
| 31 | s32 | Movie | #FriendButMarried | Rako Prijanto | Adipati Dolken, Vanesha Prescilla, Rendi Jhon,... | Indonesia | May 21, 2020 | 2018 | TV-G | 102 min | Dramas, International Movies, Romantic Movies | Pining for his high school crush for years, a ... |
twentyseventeen = movies[movies['release_year']==2017]
twentysixteen = movies[movies['release_year']==2016]
twentyfifthteen = movies[movies['release_year']==2015]
fig=fig = px.pie(movies, names='rating', title='movie ratings')
fig.show()
pio.write_html(fig,"movieratings.html", full_html=False)
fig=fig = px.pie(twentytwenty, names='rating', title='2020 ratings')
fig.show()
pio.write_html(fig,"2020movies.html", full_html=False)
fig=fig = px.pie(twentynineteen, names='rating', title='2019 ratings')
fig.show()
pio.write_html(fig,"2019movies.html", full_html=False)
fig=fig = px.pie(twentyeighteen, names='rating', title='2018 ratings')
fig.show()
pio.write_html(fig,"2018movies.html", full_html=False)
fig=fig = px.pie(twentyseventeen, names='rating', title='2017 ratings')
fig.show()
pio.write_html(fig,"2017movies.html", full_html=False)
fig=fig = px.pie(twentysixteen, names='rating', title='2016 ratings')
fig.show()
pio.write_html(fig,"2016movies.html", full_html=False)
fig=fig = px.pie(twentyfifthteen, names='rating', title='2015 ratings')
fig.show()
pio.write_html(fig,"2015movies.html", full_html=False)
fig=fig = px.pie(movies, names='rating', title='movie ratings')
fig.show()
fig=fig = px.pie(twentyeleven, names='rating', title='2011 ratings')
fig.show()
pio.write_html(fig,"2011movies.html", full_html=False)